Prepared statement issue in Pgpool-II

am 28.06.2010 23:32:03 von raghu ram

--0016364edb1c06a811048a1ddab3
Content-Type: text/plain; charset=ISO-8859-1

Hi,

We are using pgool-II version 2.3.2.2 (tomiteboshi)and postgres 8.3.9 and
facing the below error while running the select queries in the application
side::

ERROR: prepared statement
"mdb2_statement_pgsql_71417ca02c1aa9cec1dd2570c46e992e" does not exist

STATEMENT: DEALLOCATE PREPARE
mdb2_statement_pgsql_71417ca02c1aa9cec1dd2570c46e992e

WARNING: archive_mode enabled, yet archive_command is not set

In the pgpool.conf file set the "reset_query_list" ='ABORT; RESET ALL; SET
SESSION AUTHORIZATION DEFAULT'

We also tested on pgpool-II version 2.3.3, result will be same.

Please help us to resolve the issue.

Regards

Raghu

--0016364edb1c06a811048a1ddab3
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hi,

<=
p style=3D"margin: 0.0px 0.0px 0.0px 0.0px; font: 13.0px Courier">

<=
p style=3D"margin: 0.0px 0.0px 0.0px 0.0px; font: 13.0px Courier">
We are using pgool-II version 2.3.2.2 (tomiteboshi)and postgres 8.3.9 and f=
acing the below error while running the select queries in the application s=
ide::

ht: 16.0px">

=A0ERROR=
:=A0 prepared statement "mdb2_statement_pgsql_71417ca02c1aa9cec1dd2570=
c46e992e" does not exist

=A0STATE=
MENT:=A0 DEALLOCATE PREPARE mdb2_statement_pgsql_71417ca02c1aa9cec1dd2570c4=
6e992e

=A0WARNI=
NG:=A0 archive_mode enabled, yet archive_command is not set

ht: 16.0px">

In the p=
gpool.conf file set the "reset_query_list" =3D'ABORT; RE=
SET ALL; SET SESSION AUTHORIZATION DEFAULT'

ht: 16.0px">

px Courier; min-height: 16.0px">We also tested on=A0pgpool-II version 2.3.3=
, result will be same.

ht: 16.0px">

px Courier; min-height: 16.0px">Please help us to resolve the issue.

style=3D"margin: 0.0px 0.0px 0.0px 0.0px; font: 13.0px Courier">

=
Regards

r">Raghu

--0016364edb1c06a811048a1ddab3--

Re: Prepared statement issue in Pgpool-II

am 29.06.2010 09:48:34 von raghu ram

--001517511876e39215048a2676d3
Content-Type: text/plain; charset=ISO-8859-1

On Tue, Jun 29, 2010 at 3:25 PM, Vibhor Kumar > wrote:

> On 28/06/10 10:32 PM, raghu ram wrote:
>
>>
>> ERROR: prepared statement
>> "mdb2_statement_pgsql_71417ca02c1aa9cec1dd2570c46e992e" does not exist
>>
>> STATEMENT: DEALLOCATE PREPARE
>> mdb2_statement_pgsql_71417ca02c1aa9cec1dd2570c46e992e
>>
>> WARNING: archive_mode enabled, yet archive_command is not set
>>
>>
>> In the pgpool.conf file set the "reset_query_list" ='ABORT; RESET ALL;
>> SET SESSION AUTHORIZATION DEFAULT'
>>
>>
> Change the parameter setting reset_query_list = 'ABORT; DISCARD ALL'
>
>
Thanks Vibhor...

If you set the reset_query_list = 'ABORT; DISCARD ALL'
(or) reset_query_list = 'ABORT; DISCARD TEMPORARY' also getting the same
error again for both version of the Pgpool-II.

Thanks&Regards
Raghu

--
> Thanks& Regards,
> Vibhor Kumar.
> Senior System Engineer.
>
> EnterpriseDB Corporation
> The Enterprise Postgres Company
>
> Office: 732-331-1300 Ext-2022
>
> Website: www.enterprisedb.com
> EnterpriseDB Blog: http://blogs.enterprisedb.com
> Follow us on Twitter: http://www.twitter.com/enterprisedb
>
>

--001517511876e39215048a2676d3
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

On Tue, Jun 29, 2010 at 3:25 PM, Vibhor =
Kumar < ">vibhor.kumar@enterprisedb.com> wrote:

=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padd=
ing-left:1ex;">

On 28/06/10 10:32 PM, raghu ram wrote:

x #ccc solid;padding-left:1ex">

ERROR: =A0prepared statement "mdb2_statement_pgsql_71417ca02c1aa9cec1d=
d2570c46e992e" does not exist

=A0STATEMENT: =A0DEALLOCATE PREPARE mdb2_statement_pgsql_71417ca02c1aa9cec1=
dd2570c46e992e

=A0WARNING: =A0archive_mode enabled, yet archive_command is not set

In the pgpool.conf file set the =A0"reset_query_list" =3D'ABO=
RT; RESET ALL; SET SESSION AUTHORIZATION DEFAULT'

Change the parameter setting reset_query_list =3D 'ABORT; DISCARD ALL&#=
39;

Thanks Vibhor...

If you set the =A0reset_query_list =3D 'ABORT; DISCARD ALL&#=
39; =A0(or)=A0reset_query_list =3D 'ABORT; DISCARD TEMPORARY' also =
getting the same error again for both version of the Pgpool-II.

Thanks&Regards

Raghu

rgin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"> =3D"#888888">
--

Thanks& =A0Regards,

Vibhor Kumar.

Senior System Engineer.

EnterpriseDB Corporation

The Enterprise Postgres Company

Office: 732-331-1300 Ext-2022

Website: www.ente=
rprisedb.com

EnterpriseDB Blog: nk">http://blogs.enterprisedb.com

Follow us on Twitter: t=3D"_blank">http://www.twitter.com/enterprisedb

--001517511876e39215048a2676d3--

Re: Prepared statement issue in Pgpool-II

am 29.06.2010 11:55:58 von Vibhor Kumar

On 28/06/10 10:32 PM, raghu ram wrote:
>
> ERROR: prepared statement
> "mdb2_statement_pgsql_71417ca02c1aa9cec1dd2570c46e992e" does not exist
>
> STATEMENT: DEALLOCATE PREPARE
> mdb2_statement_pgsql_71417ca02c1aa9cec1dd2570c46e992e
>
> WARNING: archive_mode enabled, yet archive_command is not set
>
>
> In the pgpool.conf file set the "reset_query_list" ='ABORT; RESET
> ALL; SET SESSION AUTHORIZATION DEFAULT'
>

Change the parameter setting reset_query_list = 'ABORT; DISCARD ALL'

--
Thanks& Regards,
Vibhor Kumar.
Senior System Engineer.
EnterpriseDB Corporation
The Enterprise Postgres Company

Office: 732-331-1300 Ext-2022

Website: www.enterprisedb.com
EnterpriseDB Blog: http://blogs.enterprisedb.com
Follow us on Twitter: http://www.twitter.com/enterprisedb

--
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice